﻿CREATE PROCEDURE [dbo].[MatchPublishers]
	@publisherName nvarchar(100),
	@city nvarchar(50)
AS
	select	*
	from	PublisherView as pv
	where	(@publisherName is null or @publisherName = pv.PublisherName) and
			(@city is null or @city = pv.City)
	order	by pv.PublisherName;
RETURN 0